| Ranges and Lookup Functions |
Working with Named Ranges |
|
Vlookup and Hlookup Functions |
| Data Management |
Importing Files |
|
Custom and Conditional Formats |
|
Validating Data |
| Group Editing |
Sharing and Protecting Files |
|
Using Comments |
|
Tracking Workbook Changes |
| Auditing, Scenarios and Reporting |
Using Auditing Tools |
|
Using the Scenario Manager |
|
Using Custom Views |
|
Working with Report Manager |
| Database and Analysis Tools |
Working with Databases |
|
Filtering Data |
|
Sorting and Subtotalling |
|
Goal Seek and Goal Solver |
| PivotTables |
Working with PivotTables |
|
PivotTables on the Web |
